package soft.edu.dao;

import org.apache.ibatis.annotations.Param;
import soft.edu.pojo.SchMajorCatalog;
import soft.edu.pojo.SchMajorCatalogWithBLOBs;

import java.util.List;

public interface SchMajorCatalogMapper {
    int deleteByPrimaryKey(Integer majId);

    int insert(SchMajorCatalogWithBLOBs record);

    int insertSelective(SchMajorCatalogWithBLOBs record);

    SchMajorCatalogWithBLOBs selectByPrimaryKey(Integer majId);

    int updateByPrimaryKeySelective(SchMajorCatalogWithBLOBs record);

    int updateByPrimaryKeyWithBLOBs(SchMajorCatalogWithBLOBs record);

    int updateByPrimaryKey(SchMajorCatalog record);

    //根据院校名称获取所有专业信息
    List<SchMajorCatalog> getInfo(
            @Param("year") String year,
            @Param("maj_uni_name") String maj_uni_name,
            @Param("maj_college_name") String maj_college_name,
            @Param("maj_name") String maj_name);

    //返回院系列表
    List<String> getCollege(@Param("maj_uni_name") String maj_uni_name);

    //返回专业列表
    List<String> getMajor(@Param("maj_uni_name") String maj_uni_name);

    //根据学科类型返回对应的专业目录(有学科评估等级)
    List<String> getMajorwithSubject(@Param("maj_subject") String maj_subject);

}